create or replace view v_res_value_object as
select
   t1.t_res_value_object_id,
   t1.t_res_value_object_class_id,
   t2.name as Value_object_class_name,
   t1.name,
   t1.code,
   t1.order_no,
   t1.data_status,
   t1.description
from
   T_RES_VALUE_OBJECT t1,
   T_RES_VALUE_OBJECT_CLASS t2
where
   t1.t_res_value_object_class_id = t2.t_res_value_object_class_id
order by
   t2.name ASC,
   t1.order_no ASC;
